I. mathematical functionsABS (x) returns the absolute value of x.BIN (x) returns the binary value of x (OCT returns octal, HEX returns hexadecimal)CEILING (x) returns the smallest integer greater than x.EXP (x) returns the x power of e (the base of
Mysql common function summary (share) bitsCN.com
The following describes common functions in mysql. For more information, see.
I. mathematical functionsABS (x) returns the absolute value of x.BIN (x) returns the binary value of x (OCT returns octal,
First, mathematical functionsABS (x) returns the absolute value of XBIN (x) returns the binary of X (Oct returns octal, HEX returns hex)CEILING (x) returns the smallest integer value greater than XEXP (x) return value E (base of natural logarithm) x
first, mathematical functionsABS (x) returns the absolute value of XBIN (x) returns the binary of X (Oct returns octal, HEX returns hex)CEILING (x) returns the smallest integer value greater than XEXP (x) return value E (base of natural logarithm) x
First, mathematical functionsABS (x) returns the absolute value of XBIN (x) returns the binary of X (Oct returns octal, HEX returns hex)CEILING (x) returns the smallest integer value greater than XEXP (x) return value E (base of natural logarithm) x
First, mathematical functionsABS (x) returns the absolute value of XBIN (x) returns the binary of X (Oct returns octal, HEX returns hex)CEILING (x) returns the smallest integer value greater than XEXP (x) return value E (base of natural logarithm) x
One, the string functionASCII (char) returns the ASCII code value of a characterBit_length (str) returns the bit length of a stringCONCAT (S1,S2...,SN) to concatenate s1,s2...,sn into a stringConcat_ws (SEP,S1,S2...,SN) joins the S1,S2...,SN into a
MySql common functions such as mathematical functions and encryption functions bitsCN.com
MySql common functions, such as mathematical functions and encryption functions
There are many MySql functions. here we only list some common functions.
I.
I. mathematical functions ABS (x )?? Returns the absolute value BIN (x)? of x )?? Returns the binary value of x (OCT returns octal, HEX returns hexadecimal) CEILING (x )?? Returns the minimum integer EXP (x )?? Returns the x power FLOOR (x) of e
1. mathematical function ABS (x) returns the absolute value BIN (x) of x and returns the binary value of x (OCT returns octal, HEX returns hexadecimal) CEILING (x) returns the x power FLOOR (x) of the smallest integer value EXP (x) returned value e (
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.